2015-10-12 - 20290 - Break Fix - SNC Work Order Creation Batch Performance Improvement #sncsup #SNCProject

2015-1012 - 20290 - Break Fix - SNC Work Order Creation Batch Performance Improvement


Problem Summary
Add a field which can limit the number of Purchase Orders for which work orders shall be created.

Admin Info


Purpose
 SNC Work Order Creation Batch Performance Improvement
Requested By
 Jingsha
Issue Date
 10-12-2015
Resolved by
 Adithya
Resolved Date
 11-27-2015
Document Status
 Complete


Detailed Problem Description

(Include Screen Shots if required )
Work Order creation Job is taking long time and the WO upload job is overlapping and the confirmations are not being updated in the work orders.

Solution Analysis and Recommendations
(Include Screen Shots if required)

Add a field naming can be "Publish Date" in the input selection so that the Purchase Orders which are published in the selection date range only can be considered and create the Work Orders for those Purchase Orders.

Published Orders can be filtered from table "/1OM/ORDR1PAC100"

Test Plan

[List test scenarios/cases to be executed here]
S No
 Test Scenario
 Expected Results
WO001
 Published on Current date (NB&Z3NB)
 Wo needs to be create
WO002
 Before Publish Date on current date (NB&Z3NB)
 No Wo Create
WO003
 Partial Published Po in current date
 No Wo Create
WO004
 Publish the Po and update the changes in PO in ECC and send the IDOC from ECC
 No Wo Create
WO005
 Publish the Po and update the changes in PO in ECC and send the IDOC from ECC
and Publish again
 Wo needs to be create
WO006
 Foreground: Single Po & single line item given in the input of the program
 Wo needs to be created for the PO line
WO007
 Foreground: Partial Published Po Single Po & Line item as a Input (line item which is not published) has to be given in the input
 No Wo Shall be Created
WO008
 Background: Publish the PO and give Supplier & Publish date as a Input (multiple PO's)
 Wo needs to be create
WO009
 Foregound: After WO is created for a PO delete WO & recreate by giving the PO number as input.
 Wo needs to be create
WO010
 Foregound: After WO is created for a PO move Changes from ECC & Publish once again by giving the PO number as input.
 No Wo Create
WO011
 Multiple Vendor as a Input
 Wo needs to be create
WO012
 Performance Check Background Job multiple vendors (similar to SNP):
With MIX of Published POs, Republished POs, Not Republished POs and Not Published POs for two different Vendors.

Time taken for WO Create Step for 25 POs.
 WO needs to be created for the POs which are Published and Republished POs and No WO needs to be created for Not Republished and Not Published POs


Performance has to be improved
WO013
 Background Job: multiple vendors (similar to SNP):
With MIX of Published POs, Fully Publishing a partially confirmed PO in past & Republishing the PO (Changes made after first Publish)
 WO needs to be created for Pos which are Published and Republished and Fully Publishing a partially confirmed PO in past.

Resolution
[Provide complete technical details for configuration or programming here]
Enhance the program adding a new field in the selection "Published Date" so as to select the purchase orders with the date selection, to optimize the work order creation.

Release Information

[List Issues / Bugs identified in configuration or development]
2015-10-12 - 20290 - Release Notes - SNC Work Order Creation Batch